/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : 127.0.0.1:3306
 Source Schema         : eap

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : 65001

 Date: 24/11/2020 18:49:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
    `config_name` varchar(100) DEFAULT '' COMMENT '参数名称',
    `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',
    `config_value` varchar(500) DEFAULT '' COMMENT '参数键值',
    `config_type` char(1) DEFAULT '0' COMMENT '系统内置（0是 1否）',
    `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    `deleted` int(1) DEFAULT '0' COMMENT '逻辑删除，0：未删除，1：已删除',
    `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
    `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='参数配置表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES (1, '默认密码', 'default_pwd', '{\"initPwd\":\"12345678\",\"initSalt\":\"123456\"}', '0', '系统默认密码', 0, 'admin', '2020-06-17 11:52:41', 'admin', '2020-06-17 11:53:45');
INSERT INTO `sys_config` VALUES (2, '默认管理员', 'default_admin', 'admin', '0', '系统默认管理员', 0, 'admin', '2020-10-01 22:47:44', 'admin', '2020-10-01 22:47:44');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
    `parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '父部门id',
    `ancestors` varchar(200) NOT NULL DEFAULT '' COMMENT '祖级列表',
    `ancestors_name` varchar(500) DEFAULT '' COMMENT '祖级列表名称',
    `dept_name` varchar(30) NOT NULL DEFAULT '' COMMENT '部门名称',
    `sort` int(4) DEFAULT '0' COMMENT '显示顺序',
    `leader` varchar(255) DEFAULT NULL COMMENT '负责人',
    `status` char(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
    `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    `deleted` int(11) DEFAULT '0' COMMENT '逻辑删除，0：未删除，1：已删除',
    `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
    `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `dept_name_idx` (`dept_name`)
    ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (1, 0, '0', '-', '山东白兔科技有限公司', 1, '李阳', '0', '山东温呐科技有限公司', 0, 'admin', '2020-06-20 11:35:31', 'admin', '2020-10-04 22:54:45');
INSERT INTO `sys_dept` VALUES (2, 1, '0,1', '山东白兔科技有限公司', '济南分公司', 2, '李阳', '0', '济南分公司', 0, 'admin', '2020-06-20 11:36:48', 'admin', '2020-10-04 22:54:55');
INSERT INTO `sys_dept` VALUES (3, 2, '0,1,2', '山东白兔科技有限公司,济南分公司', '开发部', 1, '李阳', '0', '开发部', 0, 'admin', '2020-06-20 11:37:09', 'admin', '2020-10-04 11:34:47');
INSERT INTO `sys_dept` VALUES (4, 2, '0,1,2', '山东白兔科技有限公司,济南分公司', '测试部', 2, '胡丹丹', '0', '测试部', 0, 'admin', '2020-06-20 11:37:22', 'admin', '2020-10-04 11:35:00');
INSERT INTO `sys_dept` VALUES (5, 1, '0,1', '山东白兔科技有限公司', '北京分公司', 1, '李耀阳', '0', NULL, 0, 'admin', '2020-10-04 07:00:18', 'admin', '2020-10-04 22:55:00');
INSERT INTO `sys_dept` VALUES (6, 5, '0,1,5', '北京分公司,山东白兔科技有限公司', '测试部门', 0, '李耀阳', '0', NULL, 1, 'admin', '2020-10-04 07:01:38', 'admin', '2020-10-04 07:01:38');
INSERT INTO `sys_dept` VALUES (7, 5, '0,1,5', '北京分公司,山东白兔科技有限公司', '运营部门', 0, '233', '0', NULL, 1, 'admin', '2020-10-04 07:17:34', 'admin', '2020-10-04 07:17:34');
INSERT INTO `sys_dept` VALUES (8, 2, '0,1,2', '山东白兔科技有限公司,济南分公司', '财务部', 3, '李阳', '0', NULL, 0, 'admin', '2020-10-04 11:29:12', 'admin', '2020-10-04 11:29:12');
INSERT INTO `sys_dept` VALUES (9, 5, '0,1,5', '北京分公司,山东白兔科技有限公司', '测试部', 1, '李阳', '0', NULL, 0, 'admin', '2020-10-04 11:35:14', 'admin', '2020-10-04 11:35:14');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典ID',
    `dict_sort` int(4) DEFAULT '0' COMMENT '字典排序',
    `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
    `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
    `dict_type_id` int(11) DEFAULT NULL COMMENT '字典类型关联ID',
    `defaulted` char(1) DEFAULT '0' COMMENT '是否默认（0是 1否）',
    `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
    `deleted` int(11) DEFAULT '0' COMMENT '逻辑删除，0：未删除，1：已删除',
    `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
    `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` VALUES (1, 1, '成功', '0', 1, '0', '0', 0, 'admin', '2020-10-07 06:04:49', 'admin', '2020-10-07 06:20:09', '正常状态');
INSERT INTO `sys_dict_data` VALUES (2, 2, '失败', '1', 1, '0', '0', 0, 'admin', '2020-10-07 06:10:42', 'admin', '2020-10-07 06:22:07', '失败状态');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
    `dict_name` varchar(100) NOT NULL DEFAULT '' COMMENT '字典名称',
    `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
    `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
    `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    `deleted` int(11) DEFAULT '0' COMMENT '逻辑删除，0：未删除，1：已删除',
    `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
    `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `dict_type` (`dict_type`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='字典类型表';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` VALUES (1, '系统状态', 'sys_common_status', '0', '系统状态', 0, 'admin', '2020-10-07 06:01:25', 'admin', '2020-10-28 17:41:32');
COMMIT;

-- ----------------------------
-- Table structure for sys_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_login_log`;
CREATE TABLE `sys_login_log` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `request_id` varchar(32) DEFAULT NULL COMMENT '请求ID',
    `user_name` varchar(32) DEFAULT NULL COMMENT '用户名称',
    `ip` varchar(15) DEFAULT NULL COMMENT 'IP',
    `area` varchar(45) DEFAULT NULL COMMENT '区域',
    `operator` varchar(6) DEFAULT NULL COMMENT '运营商',
    `token` varchar(32) DEFAULT NULL COMMENT 'tokenMd5值',
    `type` int(11) DEFAULT NULL COMMENT '1:登录，2：登出',
    `success` int(1) NOT NULL DEFAULT '0' COMMENT '0:失败,1:成功',
    `code` int(11) DEFAULT NULL COMMENT '响应码',
    `exception_message` varchar(300) DEFAULT NULL COMMENT '失败消息记录',
    `user_agent` varchar(300) DEFAULT NULL COMMENT '浏览器名称',
    `browser_name` varchar(100) DEFAULT NULL COMMENT '浏览器名称',
    `browser_version` varchar(100) DEFAULT NULL COMMENT '浏览器版本',
    `engine_name` varchar(100) DEFAULT NULL COMMENT '浏览器引擎名称',
    `engine_version` varchar(100) DEFAULT NULL COMMENT '浏览器引擎版本',
    `os_name` varchar(100) DEFAULT NULL COMMENT '系统名称',
    `platform_name` varchar(100) DEFAULT NULL COMMENT '平台名称',
    `mobile` tinyint(1) DEFAULT NULL COMMENT '是否是手机,0:否,1:是',
    `device_name` varchar(100) DEFAULT NULL COMMENT '移动端设备名称',
    `device_model` varchar(100) DEFAULT NULL COMMENT '移动端设备型号',
    `remark` varchar(200) DEFAULT NULL COMMENT '备注',
    `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
    `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    `execute_time` int(11) DEFAULT NULL COMMENT '执行时间 ',
    PRIMARY KEY (`id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统登录日志';

-- ----------------------------
-- Table structure for sys_mail
-- ----------------------------
DROP TABLE IF EXISTS `sys_mail`;
CREATE TABLE `sys_mail` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `send_id` bigint(20) DEFAULT NULL COMMENT '发件人id',
    `send_email` varchar(255) DEFAULT NULL COMMENT '发件人邮箱地址',
    `receiver_id` bigint(20) DEFAULT NULL COMMENT '收件人id',
    `receiver_email` varchar(255) DEFAULT NULL COMMENT '收件人邮箱地址',
    `cc_id` bigint(20) DEFAULT NULL COMMENT ' 抄送者id',
    `cc_email` varchar(255) DEFAULT NULL COMMENT '抄送者邮箱地址',
    `send_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发送时间',
    `mail_subject` varchar(1000) DEFAULT NULL COMMENT '邮件主题',
    `mail_content` blob COMMENT '邮件内容',
    `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    `deleted` int(1) DEFAULT '0' COMMENT '逻辑删除，0：未删除，1：已删除',
    `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
    `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='邮件表';

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
    `menu_name` varchar(50) NOT NULL COMMENT '菜单名称',
    `menu_key` varchar(255) DEFAULT '' COMMENT '菜单标识',
    `component` varchar(255) DEFAULT NULL COMMENT '组件路径',
    `parent_id` bigint(20) DEFAULT '0' COMMENT '父菜单ID',
    `target` varchar(255) DEFAULT '' COMMENT '打开方式',
    `sort` int(4) DEFAULT '0' COMMENT '显示顺序',
    `menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
    `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
    `status` char(1) DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
    `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
    `path` varchar(200) DEFAULT '' COMMENT '路由地址',
    `is_frame` tinyint(1) DEFAULT '1' COMMENT '是否为外链（0是 1否）',
    `redirect` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '重定向',
    `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    `hidden_header` tinyint(1) unsigned DEFAULT NULL COMMENT '特殊 隐藏 PageHeader 组件中的页面带的 面包屑和页面标题栏',
    `hidden_children` tinyint(1) unsigned DEFAULT NULL COMMENT '强制菜单显示为Item而不是SubItem',
    `deleted` int(11) DEFAULT '0' COMMENT '逻辑删除，0：未删除，1：已删除',
    `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
    `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
    ) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COMMENT='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, '系统管理', 'system', 'PageView', 0, NULL, 1, 'M', NULL, '0', 'setting', '', 1, NULL, '系统管理目录', NULL, NULL, 0, 'admin', '2020-05-31 00:22:19', 'admin', '2020-10-06 05:03:48');
INSERT INTO `sys_menu` VALUES (2, '系统监控', 'monitor', 'PageView', 0, NULL, 2, 'M', NULL, '0', 'video-camera', '', 1, NULL, '系统监控目录', NULL, NULL, 0, 'admin', '2020-05-31 00:23:26', 'admin', '2020-05-31 00:23:26');
INSERT INTO `sys_menu` VALUES (3, '用户管理', 'UserList', 'system/UserList', 1, NULL, 1, 'C', 'sys:user:list', '0', 'user', '', 1, NULL, '用户管理菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:24:58', 'admin', '2020-05-31 00:24:58');
INSERT INTO `sys_menu` VALUES (4, '角色管理', 'systemRole', 'system/RoleList', 1, NULL, 2, 'C', 'sys:role:list', '0', 'team', '', 1, NULL, '角色管理菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:28:01', 'admin', '2020-05-31 00:28:01');
INSERT INTO `sys_menu` VALUES (5, '菜单管理', 'systemMenu', 'system/MenuList', 1, NULL, 3, 'C', 'syst:menu:list', '0', 'menu', '', 1, NULL, '菜单管理菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:28:11', 'admin', '2020-05-31 00:28:11');
INSERT INTO `sys_menu` VALUES (6, '部门管理', 'systemDept', 'system/DeptList', 1, NULL, 4, 'C', 'sys:dept:list', '0', 'cluster', '', 1, NULL, '部门管理菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:28:22', 'admin', '2020-05-31 00:28:22');
INSERT INTO `sys_menu` VALUES (7, '岗位管理', 'systemPost', 'system/PostList', 1, NULL, 5, 'C', 'sys:post:list', '0', 'solution', '', 1, NULL, '岗位管理菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:28:29', 'admin', '2020-05-31 00:28:29');
INSERT INTO `sys_menu` VALUES (8, '字典管理', 'systemDict', 'system/DictList', 1, NULL, 6, 'C', 'sys:dict:list', '0', 'read', '', 1, NULL, '字典管理菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:28:47', 'admin', '2020-05-31 00:28:47');
INSERT INTO `sys_menu` VALUES (9, '参数设置', 'systemConfig', 'system/ConfigList', 1, NULL, 7, 'C', 'sys:config:list', '0', 'edit', '', 1, NULL, '参数设置菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:28:52', 'admin', '2020-05-31 00:28:52');
INSERT INTO `sys_menu` VALUES (10, '通知公告 ', 'systemNotice', 'system/NoticeList', 1, NULL, 8, 'C', 'sys:notice:list', '0', 'message', '', 1, NULL, '通知公告菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:30:45', 'admin', '2020-05-31 00:30:45');
INSERT INTO `sys_menu` VALUES (11, '日志管理', 'systemLog', 'PageView', 0, NULL, 3, 'M', NULL, '0', 'container', '', 1, NULL, '日志管理菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:30:56', 'admin', '2020-05-31 00:30:56');
INSERT INTO `sys_menu` VALUES (12, '服务监控', 'serviceMonitor', 'monitor/server', 2, NULL, 1, 'C', 'monitor:server:list', '0', 'monitor', '', 1, NULL, '服务监控菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:31:13', 'admin', '2020-05-31 00:31:13');
INSERT INTO `sys_menu` VALUES (13, '操作日志', 'OperLogList', 'log/OperLogList', 11, NULL, 1, 'C', 'log:operationLog:list', '0', 'form', '', 1, NULL, '操作日志菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:45:41', 'admin', '2020-05-31 00:45:41');
INSERT INTO `sys_menu` VALUES (14, '登录日志', 'LoginLogList', 'log/LoginLogList', 11, NULL, 2, 'C', 'log:loginLog:list', '0', 'contacts', '', 1, NULL, '登录日志菜单', NULL, NULL, 0, 'admin', '2020-05-31 00:45:49', 'admin', '2020-05-31 00:45:49');
INSERT INTO `sys_menu` VALUES (15, '用户查询', NULL, NULL, 3, NULL, 1, 'F', 'sys:user:query', '0', '#', '', 1, NULL, '用户查询按钮', NULL, NULL, 0, 'admin', '2020-05-31 05:40:53', 'admin', '2020-05-31 05:40:53');
INSERT INTO `sys_menu` VALUES (16, '用户新增', NULL, NULL, 3, NULL, 2, 'F', 'sys:user:add', '0', '#', '', 1, NULL, '用户新增按钮', NULL, NULL, 0, 'admin', '2020-05-31 05:43:48', 'admin', '2020-05-31 05:43:48');
INSERT INTO `sys_menu` VALUES (17, '用户修改', NULL, NULL, 3, NULL, 3, 'F', 'sys:user:edit', '0', '#', '', 1, NULL, '用户修改按钮', NULL, NULL, 0, 'admin', '2020-05-31 05:44:16', 'admin', '2020-05-31 05:44:16');
INSERT INTO `sys_menu` VALUES (18, '用户删除', NULL, NULL, 3, NULL, 4, 'F', 'sys:user:remove', '0', '#', '', 1, NULL, '用户删除按钮', NULL, NULL, 0, 'admin', '2020-05-31 05:49:16', 'admin', '2020-05-31 05:49:16');
INSERT INTO `sys_menu` VALUES (19, '用户导出', NULL, NULL, 3, NULL, 5, 'F', 'sys:user:export', '0', '#', '', 1, NULL, '用户导出按钮', NULL, NULL, 0, 'admin', '2020-05-31 05:49:44', 'admin', '2020-05-31 05:49:44');
INSERT INTO `sys_menu` VALUES (20, '用户导入', NULL, NULL, 3, NULL, 6, 'F', 'sys:user:import', '0', '#', '', 1, NULL, '用户导入按钮', NULL, NULL, 0, 'admin', '2020-05-31 05:50:23', 'admin', '2020-05-31 05:50:23');
INSERT INTO `sys_menu` VALUES (21, '重置密码', NULL, NULL, 3, NULL, 7, 'F', 'sys:user:resetPwd', '0', '#', '', 1, NULL, '重置密码', NULL, NULL, 0, 'admin', '2020-05-31 05:50:56', 'admin', '2020-05-31 05:50:56');
INSERT INTO `sys_menu` VALUES (22, '角色查询', NULL, NULL, 4, NULL, 1, 'F', 'sys:role:query', '0', '#', '', 1, NULL, '角色查询按钮', NULL, NULL, 0, 'admin', '2020-05-31 05:52:26', 'admin', '2020-05-31 05:52:26');
INSERT INTO `sys_menu` VALUES (23, '角色新增', NULL, NULL, 4, NULL, 2, 'F', 'sys:role:add', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:53:47', 'admin', '2020-05-31 05:53:47');
INSERT INTO `sys_menu` VALUES (24, '角色删除', NULL, NULL, 4, NULL, 3, 'F', 'sys:role:edit', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:53:57', 'admin', '2020-05-31 05:53:57');
INSERT INTO `sys_menu` VALUES (25, '角色修改', NULL, NULL, 4, NULL, 4, 'F', 'sys:role:remove', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:54:03', 'admin', '2020-05-31 05:54:03');
INSERT INTO `sys_menu` VALUES (26, '角色导出', NULL, NULL, 4, NULL, 5, 'F', 'sys:role:export', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:54:13', 'admin', '2020-05-31 05:54:13');
INSERT INTO `sys_menu` VALUES (27, '菜单查询', NULL, NULL, 5, NULL, 1, 'F', 'sys:menu:query', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:55:57', 'admin', '2020-05-31 05:55:57');
INSERT INTO `sys_menu` VALUES (28, '菜单新增', NULL, NULL, 5, NULL, 2, 'F', 'sys:menu:add', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:56:06', 'admin', '2020-05-31 05:56:06');
INSERT INTO `sys_menu` VALUES (29, '菜单修改', NULL, NULL, 5, NULL, 3, 'F', 'sys:menu:edit', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:56:14', 'admin', '2020-05-31 05:56:14');
INSERT INTO `sys_menu` VALUES (30, '菜单删除', NULL, NULL, 5, NULL, 4, 'F', 'sys:menu:remove', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:56:24', 'admin', '2020-05-31 05:56:24');
INSERT INTO `sys_menu` VALUES (31, '部门查询', NULL, NULL, 6, NULL, 1, 'F', 'sys:dept:query', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:57:26', 'admin', '2020-05-31 05:57:26');
INSERT INTO `sys_menu` VALUES (32, '部门新增', NULL, NULL, 6, NULL, 2, 'F', 'sys:dept:add', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:57:33', 'admin', '2020-05-31 05:57:33');
INSERT INTO `sys_menu` VALUES (33, '部门修改', NULL, NULL, 6, NULL, 3, 'F', 'sys:dept:edit', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:57:54', 'admin', '2020-05-31 05:57:54');
INSERT INTO `sys_menu` VALUES (34, '部门删除', NULL, NULL, 6, NULL, 4, 'F', 'sys:dept:remove', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 05:58:01', 'admin', '2020-05-31 05:58:01');
INSERT INTO `sys_menu` VALUES (35, '岗位查询', NULL, NULL, 7, NULL, 1, 'F', 'sys:post:query', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:02:35', 'admin', '2020-05-31 06:02:35');
INSERT INTO `sys_menu` VALUES (36, '岗位新增', NULL, NULL, 7, NULL, 2, 'F', 'sys:post:add', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:02:43', 'admin', '2020-05-31 06:02:43');
INSERT INTO `sys_menu` VALUES (37, '岗位修改', NULL, NULL, 7, NULL, 3, 'F', 'sys:post:edit', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:02:48', 'admin', '2020-05-31 06:02:48');
INSERT INTO `sys_menu` VALUES (38, '岗位删除', NULL, NULL, 7, NULL, 4, 'F', 'sys:post:remove', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:02:55', 'admin', '2020-05-31 06:02:55');
INSERT INTO `sys_menu` VALUES (39, '字典查询', NULL, NULL, 8, NULL, 1, 'F', 'sys:dict:query', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:07:10', 'admin', '2020-05-31 06:07:10');
INSERT INTO `sys_menu` VALUES (40, '字典新增', NULL, NULL, 8, NULL, 2, 'F', 'sys:dict:add', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:07:13', 'admin', '2020-05-31 06:07:13');
INSERT INTO `sys_menu` VALUES (41, '字典修改', NULL, NULL, 8, NULL, 3, 'F', 'sys:dict:edit', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:08:19', 'admin', '2020-05-31 06:08:19');
INSERT INTO `sys_menu` VALUES (42, '字典删除', NULL, NULL, 8, NULL, 4, 'F', 'sys:dict:remove', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:08:22', 'admin', '2020-05-31 06:08:22');
INSERT INTO `sys_menu` VALUES (43, '参数查询', NULL, NULL, 9, NULL, 1, 'F', 'sys:config:query', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:09:18', 'admin', '2020-05-31 06:09:18');
INSERT INTO `sys_menu` VALUES (44, '参数新增', NULL, NULL, 9, NULL, 2, 'F', 'sys:config:add', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:09:21', 'admin', '2020-05-31 06:09:21');
INSERT INTO `sys_menu` VALUES (45, '参数修改', NULL, NULL, 9, NULL, 3, 'F', 'sys:config:edit', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:09:32', 'admin', '2020-05-31 06:09:32');
INSERT INTO `sys_menu` VALUES (46, '参数删除', NULL, NULL, 9, NULL, 4, 'F', 'sys:config:remove ', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:09:36', 'admin', '2020-05-31 06:09:36');
INSERT INTO `sys_menu` VALUES (47, '公告查询', NULL, NULL, 10, NULL, 1, 'F', 'sys:notice:query', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:11:15', 'admin', '2020-05-31 06:11:15');
INSERT INTO `sys_menu` VALUES (48, '公告新增', NULL, NULL, 10, NULL, 2, 'F', 'sys:notice:add', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:11:19', 'admin', '2020-05-31 06:11:19');
INSERT INTO `sys_menu` VALUES (49, '公告修改', NULL, NULL, 10, NULL, 3, 'F', 'sys:notice:edit', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:11:22', 'admin', '2020-05-31 06:11:22');
INSERT INTO `sys_menu` VALUES (50, '公告删除', NULL, NULL, 10, NULL, 4, 'F', 'sys:notice:remove', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:11:25', 'admin', '2020-05-31 06:11:25');
INSERT INTO `sys_menu` VALUES (51, '操作日志查询', NULL, NULL, 13, NULL, 1, 'F', 'monitor:operlog:query', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:16:31', 'admin', '2020-05-31 06:16:31');
INSERT INTO `sys_menu` VALUES (52, '操作日志删除', NULL, NULL, 13, NULL, 2, 'F', 'monitor:operlog:remove', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:16:43', 'admin', '2020-05-31 06:16:43');
INSERT INTO `sys_menu` VALUES (53, '操作日志导出', NULL, NULL, 13, NULL, 3, 'F', 'monitor:operLog:export', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:16:49', 'admin', '2020-05-31 06:16:49');
INSERT INTO `sys_menu` VALUES (54, '登录日志查询', NULL, NULL, 14, NULL, 1, 'F', 'monitor:loginLog:query', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:21:14', 'admin', '2020-05-31 06:21:14');
INSERT INTO `sys_menu` VALUES (55, '登录日志删除', NULL, NULL, 14, NULL, 2, 'F', 'monitor:loginlog:remove', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:21:24', 'admin', '2020-05-31 06:21:24');
INSERT INTO `sys_menu` VALUES (56, '登录日志导出', NULL, NULL, 14, NULL, 3, 'F', 'monitor:loginlog:export', '0', '#', '', 1, NULL, NULL, NULL, NULL, 0, 'admin', '2020-05-31 06:21:31', 'admin', '2020-05-31 06:21:31');
INSERT INTO `sys_menu` VALUES (57, '流程管理', 'act', 'PageView', 0, '', 4, 'M', NULL, '0', 'deployment-unit', '', 1, NULL, NULL, 0, 0, 0, 'admin', '2020-10-06 05:23:29', 'admin', '2020-10-06 05:30:19');
INSERT INTO `sys_menu` VALUES (58, '流程定义', 'procDef', '', 57, '', 1, 'M', NULL, '0', 'block', '', 1, NULL, NULL, 0, 0, 0, 'admin', '2020-10-06 05:34:55', 'admin', '2020-10-06 05:34:55');
COMMIT;

-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
    `notice_title` varchar(200) NOT NULL COMMENT '公告标题',
    `notice_type` char(1) NOT NULL DEFAULT '1' COMMENT '公告类型（1通知 2公告）',
    `notice_content` text COMMENT '公告内容',
    `status` char(1) DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
    `remark` varchar(255) DEFAULT NULL COMMENT '备注',
    `deleted` int(11) DEFAULT '0' COMMENT '逻辑删除，0：未删除，1：已删除',
    `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
    `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
    ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='通知公告表';

-- ----------------------------
-- Records of sys_notice
-- ----------------------------
BEGIN;
INSERT INTO `sys_notice` VALUES (1, '666', '1', NULL, '0', '66666', 1, 'admin', '2020-10-04 03:03:02', 'admin', '2020-10-04 03:05:22');
INSERT INTO `sys_notice` VALUES (2, 're', '1', NULL, '0', 'rere', 1, 'admin', '2020-10-04 03:09:10', 'admin', '2020-10-04 03:09:10');
INSERT INTO `sys_notice` VALUES (3, 'rte\'r', '1', NULL, '0', '二二二', 1, 'admin', '2020-10-04 07:14:03', 'admin', '2020-10-04 07:14:03');
INSERT INTO `sys_notice` VALUES (4, 'te\'te\'t\'t\'t', '1', NULL, '0', 'tttet', 1, 'admin', '2020-10-04 07:26:17', 'admin', '2020-10-04 07:26:17');
INSERT INTO `sys_notice` VALUES (5, '42343', '1', NULL, '0', '3434', 1, 'admin', '2020-10-05 03:48:26', 'admin', '2020-10-05 03:48:26');
INSERT INTO `sys_notice` VALUES (6, 'rrrr', '1', NULL, '0', 'rrr', 1, 'admin', '2020-10-05 03:49:53', 'admin', '2020-10-05 03:49:53');
INSERT INTO `sys_notice` VALUES (7, 'rrr', '1', NULL, '0', 'rrr', 0, 'admin', '2020-10-05 03:50:02', 'admin', '2020-10-05 03:50:02');
COMMIT;

-- ----------------------------
-- Table structure for sys_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_operation_log`;
CREATE TABLE `sys_operation_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `request_id` varchar(32) DEFAULT NULL COMMENT '请求ID',
  `user_id` bigint(18) DEFAULT NULL COMMENT '用户ID',
  `user_name` varchar(32) DEFAULT NULL COMMENT '用户名称',
  `name` varchar(200) DEFAULT NULL COMMENT '日志名称',
  `ip` varchar(15) DEFAULT NULL COMMENT 'IP',
  `area` varchar(45) DEFAULT NULL COMMENT '区域',
  `operator` varchar(6) DEFAULT NULL COMMENT '运营商',
  `path` varchar(500) DEFAULT NULL COMMENT '全路径',
  `module` varchar(100) DEFAULT NULL COMMENT '模块名称',
  `class_name` varchar(100) DEFAULT NULL COMMENT '类名',
  `method_name` varchar(100) DEFAULT NULL COMMENT '方法名称',
  `request_method` varchar(10) DEFAULT NULL COMMENT '请求方式，GET/POST/PUT/DELETE',
  `content_type` varchar(100) DEFAULT NULL COMMENT '内容类型',
  `request_body` tinyint(1) DEFAULT NULL COMMENT '是否是JSON请求映射参数',
  `param` text COMMENT '请求参数',
  `token` varchar(32) DEFAULT NULL COMMENT 'tokenMd5值',
  `type` int(11) DEFAULT NULL COMMENT '0:其它,1:新增,2:修改,3:删除,4:详情查询,5:所有列表,6:分页列表,7:其它查询,8:上传文件',
  `success` int(1) DEFAULT NULL COMMENT '0:失败,1:成功',
  `code` int(11) DEFAULT NULL COMMENT '响应结果状态码',
  `message` varchar(100) DEFAULT NULL COMMENT '响应结果消息',
  `result` text COMMENT '响应结果',
  `exception_name` varchar(200) DEFAULT NULL COMMENT '异常类名称',
  `exception_message` text COMMENT '异常信息',
  `browser_name` varchar(100) DEFAULT NULL COMMENT '浏览器名称',
  `browser_version` varchar(100) DEFAULT NULL COMMENT '浏览器版本',
  `engine_name` varchar(100) DEFAULT NULL COMMENT '浏览器引擎名称',
  `engine_version` varchar(100) DEFAULT NULL COMMENT '浏览器引擎版本',
  `os_name` varchar(100) DEFAULT NULL COMMENT '系统名称',
  `platform_name` varchar(100) DEFAULT NULL COMMENT '平台名称',
  `mobile` tinyint(1) DEFAULT NULL COMMENT '是否是手机,0:否,1:是',
  `device_name` varchar(100) DEFAULT NULL COMMENT '移动端设备名称',
  `device_model` varchar(100) DEFAULT NULL COMMENT '移动端设备型号',
  `execute_time` int(11) DEFAULT NULL COMMENT '执行时间',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统操作日志';

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `post_code` varchar(64) NOT NULL COMMENT '岗位编码',
  `post_name` varchar(50) NOT NULL COMMENT '岗位名称',
  `sort` int(4) NOT NULL COMMENT '显示顺序',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `deleted` int(11) DEFAULT '0' COMMENT '逻辑删除，0：未删除，1：已删除',
  `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='岗位信息表';

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_post` VALUES (1, 'ceo', '董事长', 1, '0', '董事长', 0, 'admin', '2020-05-31 00:00:39', 'admin', '2020-05-31 00:00:39');
INSERT INTO `sys_post` VALUES (2, 'se', '项目经理', 2, '0', '项目经理', 0, 'admin', '2020-05-31 00:01:32', 'admin', '2020-05-31 00:01:32');
INSERT INTO `sys_post` VALUES (3, 'leader', '项目负责人', 3, '0', '项目负责人', 0, 'admin', '2020-07-14 03:41:40', 'admin', '2020-05-31 00:01:32');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串',
  `sort` int(4) NOT NULL COMMENT '显示顺序',
  `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限5：仅本人数据权限）',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '角色状态（0正常 1停用）',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `deleted` int(11) DEFAULT '0' COMMENT '逻辑删除，0：未删除，1：已删除',
  `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='角色信息表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '超级管理员', 'admin', 1, '1', '0', '超级管理员', 0, 'admin', '2020-10-07 04:40:09', 'admin', '2020-10-07 11:19:27');
INSERT INTO `sys_role` VALUES (2, '管理员', 'manager', 1, '1', '0', '普通管理员', 0, 'admin', '2020-06-27 04:49:46', 'admin', '2020-06-27 04:49:39');
INSERT INTO `sys_role` VALUES (3, '普通角色', 'common', 1, '2', '0', '普通角色', 0, 'admin', '2020-10-07 05:09:37', 'admin', '2020-10-07 12:09:37');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`,`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和部门关联表';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_dept` VALUES (3, 1);
INSERT INTO `sys_role_dept` VALUES (3, 3);
INSERT INTO `sys_role_dept` VALUES (3, 4);
INSERT INTO `sys_role_dept` VALUES (3, 8);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (1, 1);
INSERT INTO `sys_role_menu` VALUES (1, 2);
INSERT INTO `sys_role_menu` VALUES (1, 3);
INSERT INTO `sys_role_menu` VALUES (1, 4);
INSERT INTO `sys_role_menu` VALUES (1, 5);
INSERT INTO `sys_role_menu` VALUES (1, 6);
INSERT INTO `sys_role_menu` VALUES (1, 7);
INSERT INTO `sys_role_menu` VALUES (1, 8);
INSERT INTO `sys_role_menu` VALUES (1, 9);
INSERT INTO `sys_role_menu` VALUES (1, 10);
INSERT INTO `sys_role_menu` VALUES (1, 11);
INSERT INTO `sys_role_menu` VALUES (1, 12);
INSERT INTO `sys_role_menu` VALUES (1, 13);
INSERT INTO `sys_role_menu` VALUES (1, 14);
INSERT INTO `sys_role_menu` VALUES (1, 15);
INSERT INTO `sys_role_menu` VALUES (1, 16);
INSERT INTO `sys_role_menu` VALUES (1, 17);
INSERT INTO `sys_role_menu` VALUES (1, 18);
INSERT INTO `sys_role_menu` VALUES (1, 19);
INSERT INTO `sys_role_menu` VALUES (1, 20);
INSERT INTO `sys_role_menu` VALUES (1, 21);
INSERT INTO `sys_role_menu` VALUES (1, 22);
INSERT INTO `sys_role_menu` VALUES (1, 23);
INSERT INTO `sys_role_menu` VALUES (1, 24);
INSERT INTO `sys_role_menu` VALUES (1, 25);
INSERT INTO `sys_role_menu` VALUES (1, 26);
INSERT INTO `sys_role_menu` VALUES (1, 27);
INSERT INTO `sys_role_menu` VALUES (1, 28);
INSERT INTO `sys_role_menu` VALUES (1, 29);
INSERT INTO `sys_role_menu` VALUES (1, 30);
INSERT INTO `sys_role_menu` VALUES (1, 31);
INSERT INTO `sys_role_menu` VALUES (1, 32);
INSERT INTO `sys_role_menu` VALUES (1, 33);
INSERT INTO `sys_role_menu` VALUES (1, 34);
INSERT INTO `sys_role_menu` VALUES (1, 35);
INSERT INTO `sys_role_menu` VALUES (1, 36);
INSERT INTO `sys_role_menu` VALUES (1, 37);
INSERT INTO `sys_role_menu` VALUES (1, 38);
INSERT INTO `sys_role_menu` VALUES (1, 39);
INSERT INTO `sys_role_menu` VALUES (1, 40);
INSERT INTO `sys_role_menu` VALUES (1, 41);
INSERT INTO `sys_role_menu` VALUES (1, 42);
INSERT INTO `sys_role_menu` VALUES (1, 43);
INSERT INTO `sys_role_menu` VALUES (1, 44);
INSERT INTO `sys_role_menu` VALUES (1, 45);
INSERT INTO `sys_role_menu` VALUES (1, 46);
INSERT INTO `sys_role_menu` VALUES (1, 47);
INSERT INTO `sys_role_menu` VALUES (1, 48);
INSERT INTO `sys_role_menu` VALUES (1, 49);
INSERT INTO `sys_role_menu` VALUES (1, 50);
INSERT INTO `sys_role_menu` VALUES (1, 51);
INSERT INTO `sys_role_menu` VALUES (1, 52);
INSERT INTO `sys_role_menu` VALUES (1, 53);
INSERT INTO `sys_role_menu` VALUES (1, 54);
INSERT INTO `sys_role_menu` VALUES (1, 55);
INSERT INTO `sys_role_menu` VALUES (1, 56);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `user_name` varchar(255) NOT NULL COMMENT '登录账号',
  `user_number` varchar(255) NOT NULL COMMENT '工号',
  `nick_name` varchar(255) DEFAULT '' COMMENT '用户昵称',
  `user_type` varchar(2) DEFAULT '00' COMMENT '用户类型（00系统用户 01注册用户）',
  `email` varchar(50) DEFAULT '' COMMENT '用户邮箱',
  `phone` varchar(13) DEFAULT '' COMMENT '座机',
  `mobile` varchar(11) DEFAULT '' COMMENT '手机',
  `gender` tinyint(4) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) DEFAULT '' COMMENT '头像路径',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '所属部门',
  `password` varchar(100) DEFAULT '' COMMENT '密码',
  `salt` varchar(20) DEFAULT '' COMMENT '盐加密',
  `status` char(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `login_ip` varchar(50) DEFAULT '' COMMENT '最后登陆IP',
  `login_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后登陆时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `deleted` int(11) DEFAULT '0' COMMENT '逻辑删除，0：未删除，1：已删除',
  `create_by` varchar(255) DEFAULT '' COMMENT '创建者',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT '' COMMENT '更新者',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`,`user_number`) USING BTREE,
  UNIQUE KEY `idx_user_name` (`user_name`),
  UNIQUE KEY `idx_user_number` (`user_number`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='用户信息表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', 'admin', 'admin', '00', 'admin@jinanxunhua.com', '', '15063359913', 0, '', 1, '12f319d12da918a39bac9892c9975687e0156207b43fa3496ea98bdc72b0e390', '123456', '0', '127.0.0.1', '2020-10-29 17:29:16', '超级管理员', 0, 'admin', '2020-06-01 05:11:07', NULL, '2020-10-29 17:29:16');
INSERT INTO `sys_user` VALUES (2, 'liyang', '10000', '李阳', '00', 'liyang@jinanxunhua.com', '', '15063359912', 0, '', 2, '12f319d12da918a39bac9892c9975687e0156207b43fa3496ea98bdc72b0e390', '123456', '0', '127.0.0.1', '2020-06-01 11:14:45', '管理员', 1, 'admin', '2020-06-01 11:14:45', 'admin', '2020-10-28 10:57:14');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_dept`;
CREATE TABLE `sys_user_dept` (
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `dept_id` bigint(20) NOT NULL COMMENT '部门id',
  `post_id` bigint(20) NOT NULL COMMENT '岗位id',
  PRIMARY KEY (`user_id`,`dept_id`,`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户附属机构关系表';

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `post_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户与岗位关联表';

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_post` VALUES (1, 1);
INSERT INTO `sys_user_post` VALUES (2, 1);
INSERT INTO `sys_user_post` VALUES (2, 2);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户和角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (1, 1);
INSERT INTO `sys_user_role` VALUES (2, 2);
INSERT INTO `sys_user_role` VALUES (2, 3);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
